<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>无标题文档</title>
</head>

<body>
	<?php  include 'action/session_check.php'; //登录判断  ?>  
<table>
<tr>
<td colspan="13">用户信息管理</td></tr>
<tr>
      <td>编号</td><td>用户名</td><td>性别</td><td>出生日期</td><td>现居地址</td><td>学历</td>
      <td>电话</td><td>电子邮箱</td><td>注册时间</td><td>状态</td>
      <td colspan="4">操作</td>
    </tr>
 <?php   
   require_once("../conn/conn_db.php");  //包含数据库连接文件
   $sql = "select * from  user_info order by u_createtime desc"; //查询语句
   $result = $conn->query($sql);              //执行SQL语句
   while($row = $result->fetch_array())//遍历查询结果的每一行
  {
?>
  <tr class="tr_content">
    <td> <?php echo $row["u_id"];?>    </td>
    <td> <?php echo $row["u_name"];?>  </td>
    <td> <?php echo $row["u_sex"];?>  </td>
    <td> <?php echo $row["u_birth"];?>   </td>
    <td> <?php echo $row["u_city"];?>    </td>
    <td> <?php echo $row["u_education"];?> </td>
    <td> <?php echo $row["u_tel"];?></td>
    <td> <?php echo $row["u_email"];?>  </td>
    <td> <?php echo $row["u_createtime"];?></td>
    <td> <?php echo $row["u_status"]=='1'? '<font color=blue>启用</font>':'<font color=red>禁用</font>';?>  </td>
    <td><a  href="action/user_action_do.php?Type=1&u_id=<?php echo $row["u_id"];?>">启用</a></td>
    <td><a  href="action/user_action_do.php?Type=2&u_id=<?php echo $row["u_id"];?>">禁用</a></td>
    <td><a  href="action/user_action_do.php?Type=3&u_id=<?php echo $row["u_id"];?>">删除</a></td>
    <td><a  href="user_info.php?u_id=<?php echo $row["u_id"];?>">详细信息</a></td>
  </tr>
<?php }  ?>
 </table>
</body>
</html>